package com.hqyj.system.mapper;

import com.hqyj.system.model.Employee;
import com.hqyj.system.model.vo.EmployeeVO;
import org.apache.ibatis.annotations.Param;

import java.util.HashMap;
import java.util.List;

public interface EmployeeMapper {
    //1.增加
    //2.修改
    //3.删除
    int deleteEmployeeByEmployeeId(int employeeId);
    //4.1 查询:id
    Employee queryEmployeeByEmployeeId(int employeeId);
    //4.2查询:all
    List<Employee> queryAllEmployee();
    //
    int addEmployeeBy(Employee employee);
    //
    int updateEmployeeBy(Employee employee);

    Employee queryEmployeeByName(String name);

    List<Employee> queryEmployeeByNameLike(String name);

    List<Employee> queryEmployeeByNameLike2(String name);

    List<Employee> queryEmployeeByNameAndSex(@Param("name") String name, @Param("sex") String sex);

    List<Employee> queryEmployeeByNameAndSex2(HashMap<String,Object> map);

    List<EmployeeVO> queryEmployeeVOByNameAndSex(HashMap<String, Object> map);

    List<Employee> queryEmployeeByName2(String name);
//
}
